Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	7327407
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.5 GiB
Average record size in memory	510.7 B

Variable types

DateTime	4
Numeric	11
Text	5
Categorical	4

Alerts

`order_take_out_type_label` is highly imbalanced (60.5%)	Imbalance
`bill_total_billed` is highly skewed (γ1 = 169.5718289)	Skewed
`bill_total_discount_item_level` is highly skewed (γ1 = 116.7694495)	Skewed
`bill_total_gratuity` is highly skewed (γ1 = 501.5964988)	Skewed
`bill_total_net` is highly skewed (γ1 = 157.400082)	Skewed
`bill_total_tax` is highly skewed (γ1 = 305.4724136)	Skewed
`bill_total_voided` is highly skewed (γ1 = 665.3228541)	Skewed
`payment_amount` is highly skewed (γ1 = 1987.839703)	Skewed
`payment_total_tip` is highly skewed (γ1 = 2683.250401)	Skewed
`sales_revenue_with_tax` is highly skewed (γ1 = 169.5704025)	Skewed
`bill_uuid` has unique values	Unique
`bill_total_billed` has 192204 (2.6%) zeros	Zeros
`bill_total_discount_item_level` has 6770774 (92.4%) zeros	Zeros
`bill_total_gratuity` has 7157347 (97.7%) zeros	Zeros
`bill_total_net` has 192460 (2.6%) zeros	Zeros
`bill_total_tax` has 1056107 (14.4%) zeros	Zeros
`bill_total_voided` has 7133326 (97.4%) zeros	Zeros
`payment_amount` has 193161 (2.6%) zeros	Zeros
`payment_count` has 179184 (2.4%) zeros	Zeros
`payment_total_tip` has 4276747 (58.4%) zeros	Zeros
`sales_revenue_with_tax` has 192212 (2.6%) zeros	Zeros

Reproduction

Analysis started	2025-02-12 23:20:08.063792
Analysis finished	2025-02-12 23:36:24.390803
Duration	16 minutes and 16.33 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

bill_paid_at_local
Date

Distinct	5112956
Distinct (%)	69.8%
Missing	0
Missing (%)	0.0%
Memory size	111.8 MiB

Minimum	2024-07-01 00:00:01
Maximum	2025-01-01 21:41:43
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

bill_total_billed
Real number (ℝ)

Skewed Zeros

Distinct	48338
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.28303

Minimum	-4712.1
Maximum	74928.61
Zeros	192204
Zeros (%)	2.6%
Negative	12604
Negative (%)	0.2%
Memory size	111.8 MiB

Quantile statistics

Minimum	-4712.1
5-th percentile	2.89
Q1	10.32
median	22.01
Q3	44.69
95-th percentile	108.55
Maximum	74928.61
Range	79640.71
Interquartile range (IQR)	34.37

Descriptive statistics

Standard deviation	82.053465
Coefficient of variation (CV)	2.2614833
Kurtosis	107563.33
Mean	36.28303
Median Absolute Deviation (MAD)	14.46
Skewness	169.57183
Sum	2.6586053 × 10⁸
Variance	6732.7711
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	192204	2.6%
15.5	28759	0.4%
7	26524	0.4%
11.3	26045	0.4%
6	24440	0.3%
8	23779	0.3%
18.9	22187	0.3%
12	19656	0.3%
4	19487	0.3%
6.75	19254	0.3%
Other values (48328)	6925072	94.5%

Value	Count	Frequency (%)
-4712.1	1	< 0.1%
-3323.28	1	< 0.1%
-2625	1	< 0.1%
-2433.2	1	< 0.1%
-1200	1	< 0.1%
-1000	1	< 0.1%
-773.39	1	< 0.1%
-696.03	1	< 0.1%
-651.41	1	< 0.1%
-638.2	1	< 0.1%

Value	Count	Frequency (%)
74928.61	1	< 0.1%
33928.25	1	< 0.1%
25131.48	1	< 0.1%
23132.39	1	< 0.1%
22088.31	1	< 0.1%
21000	1	< 0.1%
20551.26	1	< 0.1%
19866	1	< 0.1%
19021.08	1	< 0.1%
16589.81	1	< 0.1%

bill_total_discount_item_level
Real number (ℝ)

Skewed Zeros

Distinct	18132
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.81173694

Minimum	-74.3
Maximum	4763.45
Zeros	6770774
Zeros (%)	92.4%
Negative	524
Negative (%)	< 0.1%
Memory size	111.8 MiB

Quantile statistics

Minimum	-74.3
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2.82
Maximum	4763.45
Range	4837.75
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.4987232
Coefficient of variation (CV)	10.4698
Kurtosis	37493.172
Mean	0.81173694
Median Absolute Deviation (MAD)	0
Skewness	116.76945
Sum	5947926.9
Variance	72.228296
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6770774	92.4%
2	20086	0.3%
1	18937	0.3%
3	14649	0.2%
5	13851	0.2%
4	13299	0.2%
6	10167	0.1%
10	9229	0.1%
8	7977	0.1%
1.5	6834	0.1%
Other values (18122)	441604	6.0%

Value	Count	Frequency (%)
-74.3	1	< 0.1%
-66.25	1	< 0.1%
-62.84	1	< 0.1%
-59.06	2	< 0.1%
-58.62	2	< 0.1%
-55	1	< 0.1%
-53.6	1	< 0.1%
-53.26	1	< 0.1%
-50.27	1	< 0.1%
-44.04	1	< 0.1%

Value	Count	Frequency (%)
4763.45	1	< 0.1%
4152	1	< 0.1%
3624.71	1	< 0.1%
2912.75	1	< 0.1%
2809	1	< 0.1%
2611	1	< 0.1%
2198	1	< 0.1%
2090	1	< 0.1%
2040	1	< 0.1%
1888.8	1	< 0.1%

bill_total_gratuity
Real number (ℝ)

Skewed Zeros

Distinct	8038
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.24172149

Minimum	-60
Maximum	11935.53
Zeros	7157347
Zeros (%)	97.7%
Negative	24
Negative (%)	< 0.1%
Memory size	111.8 MiB

Quantile statistics

Minimum	-60
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	11935.53
Range	11995.53
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.722423
Coefficient of variation (CV)	36.084598
Kurtosis	539453.97
Mean	0.24172149
Median Absolute Deviation (MAD)	0
Skewness	501.5965
Sum	1771191.8
Variance	76.080663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7157347	97.7%
0.32	5362	0.1%
0.15	4588	0.1%
0.64	2047	< 0.1%
0.24	1775	< 0.1%
3.6	1367	< 0.1%
0.12	1274	< 0.1%
0.45	1256	< 0.1%
0.3	1253	< 0.1%
0.48	1102	< 0.1%
Other values (8028)	150036	2.0%

Value	Count	Frequency (%)
-60	1	< 0.1%
-37.8	1	< 0.1%
-19.08	1	< 0.1%
-18.4	1	< 0.1%
-12	1	< 0.1%
-11.79	1	< 0.1%
-9.58	1	< 0.1%
-3.87	1	< 0.1%
-2.74	1	< 0.1%
-2.44	1	< 0.1%

Value	Count	Frequency (%)
11935.53	1	< 0.1%
6005	1	< 0.1%
4029.21	1	< 0.1%
4003.25	1	< 0.1%
3402.7	1	< 0.1%
3245	1	< 0.1%
2916.32	1	< 0.1%
2504.6	1	< 0.1%
2492.6	1	< 0.1%
2469.19	1	< 0.1%

bill_total_net
Real number (ℝ)

Skewed Zeros

Distinct	36640
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.46403

Minimum	-4170
Maximum	66308.5
Zeros	192460
Zeros (%)	2.6%
Negative	12449
Negative (%)	0.2%
Memory size	111.8 MiB

Quantile statistics

Minimum	-4170
5-th percentile	2.75
Q1	9.52
median	20.24
Q3	41
95-th percentile	100
Maximum	66308.5
Range	70478.5
Interquartile range (IQR)	31.48

Descriptive statistics

Standard deviation	76.127465
Coefficient of variation (CV)	2.2749043
Kurtosis	91094.796
Mean	33.46403
Median Absolute Deviation (MAD)	13.24
Skewness	157.40008
Sum	2.4520457 × 10⁸
Variance	5795.3909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	192460	2.6%
8	65960	0.9%
18	64383	0.9%
10	58653	0.8%
16	55866	0.8%
5	55117	0.8%
15	54506	0.7%
12	53155	0.7%
6	51607	0.7%
20	46674	0.6%
Other values (36630)	6629026	90.5%

Value	Count	Frequency (%)
-4170	1	< 0.1%
-3323.28	1	< 0.1%
-2625	1	< 0.1%
-2342.09	1	< 0.1%
-1200	1	< 0.1%
-1000	1	< 0.1%
-684.42	1	< 0.1%
-647.5	1	< 0.1%
-599	1	< 0.1%
-596	1	< 0.1%

Value	Count	Frequency (%)
66308.5	1	< 0.1%
30025	1	< 0.1%
22384.5	1	< 0.1%
22240.25	1	< 0.1%
20253.15	1	< 0.1%
20050	1	< 0.1%
19866	1	< 0.1%
18985	1	< 0.1%
17256	1	< 0.1%
15398.9	1	< 0.1%

bill_total_tax
Real number (ℝ)

Skewed Zeros

Distinct	10043
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.819

Minimum	-542.1
Maximum	8620.11
Zeros	1056107
Zeros (%)	14.4%
Negative	9274
Negative (%)	0.1%
Memory size	111.8 MiB

Quantile statistics

Minimum	-542.1
5-th percentile	0
Q1	0.45
median	1.43
Q3	3.49
95-th percentile	9.75
Maximum	8620.11
Range	9162.21
Interquartile range (IQR)	3.04

Descriptive statistics

Standard deviation	7.1636406
Coefficient of variation (CV)	2.5411992
Kurtosis	306353.56
Mean	2.819
Median Absolute Deviation (MAD)	1.23
Skewness	305.47241
Sum	20655961
Variance	51.317747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1056107	14.4%
1.3	43081	0.6%
0.9	39754	0.5%
1.04	39536	0.5%
0.52	39266	0.5%
0.65	38705	0.5%
0.24	37644	0.5%
0.33	35709	0.5%
2.08	35571	0.5%
0.85	33725	0.5%
Other values (10033)	5928309	80.9%

Value	Count	Frequency (%)
-542.1	1	< 0.1%
-91.11	1	< 0.1%
-88.97	1	< 0.1%
-73.85	1	< 0.1%
-73.42	1	< 0.1%
-60.09	1	< 0.1%
-58.71	1	< 0.1%
-52.41	1	< 0.1%
-51.39	1	< 0.1%
-49.93	1	< 0.1%

Value	Count	Frequency (%)
8620.11	1	< 0.1%
3903.25	1	< 0.1%
2891.23	1	< 0.1%
2038.31	1	< 0.1%
1765.08	1	< 0.1%
1566.26	1	< 0.1%
1505.53	1	< 0.1%
1334.81	1	< 0.1%
1300	1	< 0.1%
1242.85	1	< 0.1%

bill_total_voided
Real number (ℝ)

Skewed Zeros

Distinct	9033
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.75326427

Minimum	-4501.5
Maximum	43178.4
Zeros	7133326
Zeros (%)	97.4%
Negative	510
Negative (%)	< 0.1%
Memory size	111.8 MiB

Quantile statistics

Minimum	-4501.5
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	43178.4
Range	47679.9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	27.828199
Coefficient of variation (CV)	36.943474
Kurtosis	860737.37
Mean	0.75326427
Median Absolute Deviation (MAD)	0
Skewness	665.32285
Sum	5519473.9
Variance	774.40866
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7133326	97.4%
8	4266	0.1%
9	3669	0.1%
10	3629	< 0.1%
16	3601	< 0.1%
6	3324	< 0.1%
12	3233	< 0.1%
5	3229	< 0.1%
15	2948	< 0.1%
7	2891	< 0.1%
Other values (9023)	163291	2.2%

Value	Count	Frequency (%)
-4501.5	1	< 0.1%
-1697	1	< 0.1%
-1665.9	1	< 0.1%
-1215.15	1	< 0.1%
-1173.15	1	< 0.1%
-784.81	1	< 0.1%
-538.55	1	< 0.1%
-500	1	< 0.1%
-380.75	1	< 0.1%
-313.85	1	< 0.1%

Value	Count	Frequency (%)
43178.4	1	< 0.1%
20835	1	< 0.1%
12766.5	1	< 0.1%
12749.46	1	< 0.1%
10176	1	< 0.1%
9440	1	< 0.1%
8216.42	1	< 0.1%
8000	1	< 0.1%
7312.62	1	< 0.1%
6800	1	< 0.1%

bill_uuid
Text

Unique

Distinct	7327407
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	455.0 MiB

Length

Max length	49
Median length	49
Mean length	48.988761
Min length	36

Characters and Unicode

Total characters	358960588
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7327407 ?
Unique (%)	100.0%

Sample

1st row	240702200053~8792ADCC-545E-4AF3-9836-9C428ED8285C
2nd row	240703214339~B06B2A2F-B1A0-44C0-920A-242F41B58BD2
3rd row	240703182356~D082FE98-841C-4EAB-B15E-BEA41FA1CDF0
4th row	240703193321~273CBB07-FAB0-49B7-A445-8474F9A4570F
5th row	240705210114~D423B906-1AEE-4DB8-84BA-234267A14E05

Value	Count	Frequency (%)
240702200053~8792adcc-545e-4af3-9836-9c428ed8285c	1	< 0.1%
240703214339~b06b2a2f-b1a0-44c0-920a-242f41b58bd2	1	< 0.1%
240703182356~d082fe98-841c-4eab-b15e-bea41fa1cdf0	1	< 0.1%
240703193321~273cbb07-fab0-49b7-a445-8474f9a4570f	1	< 0.1%
240705210114~d423b906-1aee-4db8-84ba-234267a14e05	1	< 0.1%
240705210926~ca81a307-a782-42d4-b81d-250556cbe839	1	< 0.1%
240705202148~a47eec00-a5af-45ba-a892-171e7cdefe7c	1	< 0.1%
240705182318~913c3f9f-e867-4e36-a3b1-e1e68fcbad16	1	< 0.1%
240706174632~1996e368-132e-43a2-9821-34bf48033ce1	1	< 0.1%
240706181722~a4851319-949c-4ff1-964d-c860684075b9	1	< 0.1%
Other values (7327397)	7327397	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
4	33548532	9.3%
1	31557189	8.8%
2	31504519	8.8%
-	29309628	8.2%
0	27344136	7.6%
9	19845498	5.5%
8	19837506	5.5%
3	19610787	5.5%
5	18804623	5.2%
7	17803302	5.0%
Other values (14)	109794868	30.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	358960588	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	33548532	9.3%
1	31557189	8.8%
2	31504519	8.8%
-	29309628	8.2%
0	27344136	7.6%
9	19845498	5.5%
8	19837506	5.5%
3	19610787	5.5%
5	18804623	5.2%
7	17803302	5.0%
Other values (14)	109794868	30.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	358960588	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	33548532	9.3%
1	31557189	8.8%
2	31504519	8.8%
-	29309628	8.2%
0	27344136	7.6%
9	19845498	5.5%
8	19837506	5.5%
3	19610787	5.5%
5	18804623	5.2%
7	17803302	5.0%
Other values (14)	109794868	30.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	358960588	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	33548532	9.3%
1	31557189	8.8%
2	31504519	8.8%
-	29309628	8.2%
0	27344136	7.6%
9	19845498	5.5%
8	19837506	5.5%
3	19610787	5.5%
5	18804623	5.2%
7	17803302	5.0%
Other values (14)	109794868	30.6%

business_date
Date

Distinct	184
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.8 MiB

Minimum	2024-07-01 00:00:00
Maximum	2024-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_duration_seconds
Real number (ℝ)

Distinct	65608
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2752.368

Minimum	-44
Maximum	86397
Zeros	122
Zeros (%)	< 0.1%
Negative	2
Negative (%)	< 0.1%
Memory size	111.8 MiB

Quantile statistics

Minimum	-44
5-th percentile	33
Q1	106
median	1111
Q3	3290
95-th percentile	9088
Maximum	86397
Range	86441
Interquartile range (IQR)	3184

Descriptive statistics

Standard deviation	6207.1318
Coefficient of variation (CV)	2.2551969
Kurtosis	74.744784
Mean	2752.368
Median Absolute Deviation (MAD)	1060
Skewness	7.6162569
Sum	2.016772 × 10¹⁰
Variance	38528485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42	26486	0.4%
43	26436	0.4%
46	26321	0.4%
45	26242	0.4%
40	26155	0.4%
44	26104	0.4%
47	25904	0.4%
41	25902	0.4%
38	25863	0.4%
48	25762	0.4%
Other values (65598)	7066232	96.4%

Value	Count	Frequency (%)
-44	1	< 0.1%
-19	1	< 0.1%
0	122	< 0.1%
1	2155	< 0.1%
2	5486	0.1%
3	4312	0.1%
4	6022	0.1%
5	6382	0.1%
6	5637	0.1%
7	5224	0.1%

Value	Count	Frequency (%)
86397	1	< 0.1%
86396	1	< 0.1%
86394	1	< 0.1%
86392	1	< 0.1%
86391	1	< 0.1%
86387	1	< 0.1%
86384	2	< 0.1%
86383	1	< 0.1%
86382	1	< 0.1%
86381	1	< 0.1%

order_seated_at_local
Date

Distinct	4761314
Distinct (%)	65.0%
Missing	0
Missing (%)	0.0%
Memory size	111.8 MiB

Minimum	2024-06-30 08:54:47
Maximum	2025-01-01 18:57:30
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_closed_at_local
Date

Distinct	5083978
Distinct (%)	69.4%
Missing	0
Missing (%)	0.0%
Memory size	111.8 MiB

Minimum	2024-07-01 00:00:01
Maximum	2025-01-01 21:41:43
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_take_out_type_label
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.8 MiB

dinein	6010445
takeout	859617
onlineorder	264578
bartab	180981
delivery	11786

Length

Max length	11
Median length	6
Mean length	6.3010723
Min length	6

Characters and Unicode

Total characters	46170521
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	dinein
2nd row	dinein
3rd row	dinein
4th row	dinein
5th row	dinein

Common Values

Value	Count	Frequency (%)
dinein	6010445	82.0%
takeout	859617	11.7%
onlineorder	264578	3.6%
bartab	180981	2.5%
delivery	11786	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dinein	6010445	82.0%
takeout	859617	11.7%
onlineorder	264578	3.6%
bartab	180981	2.5%
delivery	11786	0.2%

Most occurring characters

Value	Count	Frequency (%)
n	12550046	27.2%
i	12297254	26.6%
e	7422790	16.1%
d	6286809	13.6%
t	1900215	4.1%
o	1388773	3.0%
a	1221579	2.6%
k	859617	1.9%
u	859617	1.9%
r	721923	1.6%
Other values (4)	661898	1.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	46170521	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	12550046	27.2%
i	12297254	26.6%
e	7422790	16.1%
d	6286809	13.6%
t	1900215	4.1%
o	1388773	3.0%
a	1221579	2.6%
k	859617	1.9%
u	859617	1.9%
r	721923	1.6%
Other values (4)	661898	1.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	46170521	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	12550046	27.2%
i	12297254	26.6%
e	7422790	16.1%
d	6286809	13.6%
t	1900215	4.1%
o	1388773	3.0%
a	1221579	2.6%
k	859617	1.9%
u	859617	1.9%
r	721923	1.6%
Other values (4)	661898	1.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	46170521	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	12550046	27.2%
i	12297254	26.6%
e	7422790	16.1%
d	6286809	13.6%
t	1900215	4.1%
o	1388773	3.0%
a	1221579	2.6%
k	859617	1.9%
u	859617	1.9%
r	721923	1.6%
Other values (4)	661898	1.4%

order_uuid
Text

Distinct	6724735
Distinct (%)	91.8%
Missing	0
Missing (%)	0.0%
Memory size	455.0 MiB

Length

Max length	49
Median length	49
Mean length	48.988761
Min length	36

Characters and Unicode

Total characters	358960588
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6384062 ?
Unique (%)	87.1%

Sample

1st row	240702183622~4B0A3D27-501D-4C94-BEBC-7B7F3C91A0F4
2nd row	240703194731~40651D6D-4A16-4889-8C12-0F9A00D8BCF7
3rd row	240703175025~0AEB61B0-220A-45A3-807E-78A1F432BB4C
4th row	240703180201~4B276496-BE92-4DE6-BD75-565929827014
5th row	240705194141~F90FEB4F-D238-449E-B476-D16966DF4EEC

Value	Count	Frequency (%)
240914174325~01482558-0947-4341-8662-cf4eb18cc045	52	< 0.1%
240913225853~632e2003-bd52-4c2d-a42d-cbe90c35535a	43	< 0.1%
241018211013~83c159f1-9998-42ae-b8e2-06154a4a495f	39	< 0.1%
240726211619~ce2ffa2c-3bb0-49f9-a695-f3bb0d074c73	38	< 0.1%
241012223955~38741a41-132a-4818-a003-c9dc425e4ed0	33	< 0.1%
241012194904~25c7b69f-c134-421a-ae23-927c922fa034	32	< 0.1%
241108234708~11accc10-5fbc-4559-84f0-73e7a8340afa	31	< 0.1%
240920223808~092fe466-3c2a-46ef-8898-684dce87cd8b	30	< 0.1%
241130223622~7e197c00-0901-4da1-baf9-b9376c261ef6	30	< 0.1%
241206233002~1066d6f0-1fd0-42c2-a919-be9e46763e88	30	< 0.1%
Other values (6724725)	7327049	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
4	33478345	9.3%
1	32005804	8.9%
2	31026448	8.6%
-	29309628	8.2%
0	27181486	7.6%
8	19982388	5.6%
9	19852290	5.5%
3	19500073	5.4%
5	18751295	5.2%
7	17986919	5.0%
Other values (14)	109885912	30.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	358960588	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	33478345	9.3%
1	32005804	8.9%
2	31026448	8.6%
-	29309628	8.2%
0	27181486	7.6%
8	19982388	5.6%
9	19852290	5.5%
3	19500073	5.4%
5	18751295	5.2%
7	17986919	5.0%
Other values (14)	109885912	30.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	358960588	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	33478345	9.3%
1	32005804	8.9%
2	31026448	8.6%
-	29309628	8.2%
0	27181486	7.6%
8	19982388	5.6%
9	19852290	5.5%
3	19500073	5.4%
5	18751295	5.2%
7	17986919	5.0%
Other values (14)	109885912	30.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	358960588	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	33478345	9.3%
1	32005804	8.9%
2	31026448	8.6%
-	29309628	8.2%
0	27181486	7.6%
8	19982388	5.6%
9	19852290	5.5%
3	19500073	5.4%
5	18751295	5.2%
7	17986919	5.0%
Other values (14)	109885912	30.6%

payment_amount
Real number (ℝ)

Skewed Zeros

Distinct	55550
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.138697

Minimum	-4712.1
Maximum	522752.27
Zeros	193161
Zeros (%)	2.6%
Negative	12468
Negative (%)	0.2%
Memory size	111.8 MiB

Quantile statistics

Minimum	-4712.1
5-th percentile	2.98
Q1	10.92
median	23.65
Q3	48.9
95-th percentile	122.5
Maximum	522752.27
Range	527464.37
Interquartile range (IQR)	37.98

Descriptive statistics

Standard deviation	214.56711
Coefficient of variation (CV)	5.3456421
Kurtosis	4810881.6
Mean	40.138697
Median Absolute Deviation (MAD)	15.75
Skewness	1987.8397
Sum	2.9411257 × 10⁸
Variance	46039.045
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	193161	2.6%
15.5	25022	0.3%
7	23095	0.3%
6	22025	0.3%
11.3	19907	0.3%
5	18593	0.3%
12	18589	0.3%
8	18586	0.3%
6.75	18427	0.3%
3	18230	0.2%
Other values (55540)	6951772	94.9%

Value	Count	Frequency (%)
-4712.1	1	< 0.1%
-3323.28	1	< 0.1%
-2625	1	< 0.1%
-2433.2	1	< 0.1%
-1200	1	< 0.1%
-1000	1	< 0.1%
-773.39	1	< 0.1%
-696.03	1	< 0.1%
-691.41	1	< 0.1%
-638.2	1	< 0.1%

Value	Count	Frequency (%)
522752.27	1	< 0.1%
86864.14	1	< 0.1%
39933.25	1	< 0.1%
29134.73	1	< 0.1%
27161.6	1	< 0.1%
25333.31	1	< 0.1%
25050.63	1	< 0.1%
24348.26	1	< 0.1%
23786.14	1	< 0.1%
22946	1	< 0.1%

payment_count
Real number (ℝ)

Zeros

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.9837173

Minimum	0
Maximum	41
Zeros	179184
Zeros (%)	2.4%
Negative	0
Negative (%)	0.0%
Memory size	111.8 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	41
Range	41
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.19496385
Coefficient of variation (CV)	0.19819093
Kurtosis	610.22941
Mean	0.9837173
Median Absolute Deviation (MAD)	0
Skewness	4.9853598
Sum	7208097
Variance	0.038010902
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1	7098389	96.9%
0	179184	2.4%
2	43787	0.6%
3	4124	0.1%
4	1029	< 0.1%
5	470	< 0.1%
6	191	< 0.1%
7	96	< 0.1%
8	46	< 0.1%
9	28	< 0.1%
Other values (15)	63	< 0.1%

Value	Count	Frequency (%)
0	179184	2.4%
1	7098389	96.9%
2	43787	0.6%
3	4124	0.1%
4	1029	< 0.1%
5	470	< 0.1%
6	191	< 0.1%
7	96	< 0.1%
8	46	< 0.1%
9	28	< 0.1%

Value	Count	Frequency (%)
41	1	< 0.1%
29	1	< 0.1%
27	1	< 0.1%
23	1	< 0.1%
22	2	< 0.1%
20	1	< 0.1%
19	1	< 0.1%
18	2	< 0.1%
17	2	< 0.1%
16	3	< 0.1%

payment_total_tip
Real number (ℝ)

Skewed Zeros

Distinct	11413
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.6178704

Minimum	-253.14
Maximum	522715.64
Zeros	4276747
Zeros (%)	58.4%
Negative	100
Negative (%)	< 0.1%
Memory size	111.8 MiB

Quantile statistics

Minimum	-253.14
5-th percentile	0
Q1	0
median	0
Q3	4.2
95-th percentile	16.41
Maximum	522715.64
Range	522968.78
Interquartile range (IQR)	4.2

Descriptive statistics

Standard deviation	193.67719
Coefficient of variation (CV)	53.533478
Kurtosis	7240831.5
Mean	3.6178704
Median Absolute Deviation (MAD)	0
Skewness	2683.2504
Sum	26509609
Variance	37510.852
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4276747	58.4%
5	145569	2.0%
2	122759	1.7%
10	116203	1.6%
1	107670	1.5%
3	83271	1.1%
4	57886	0.8%
20	49432	0.7%
6	47655	0.7%
8	41089	0.6%
Other values (11403)	2279126	31.1%

Value	Count	Frequency (%)
-253.14	1	< 0.1%
-207.36	1	< 0.1%
-198.42	1	< 0.1%
-189.5	1	< 0.1%
-179.9	1	< 0.1%
-129.8	1	< 0.1%
-101.7	1	< 0.1%
-99	1	< 0.1%
-83.88	1	< 0.1%
-79.7	1	< 0.1%

Value	Count	Frequency (%)
522715.64	1	< 0.1%
23762.38	1	< 0.1%
17668.02	1	< 0.1%
5180.16	1	< 0.1%
4050.63	1	< 0.1%
3797	1	< 0.1%
3080	1	< 0.1%
2714.25	1	< 0.1%
2635.09	1	< 0.1%
2338.94	1	< 0.1%

sales_revenue_with_tax
Real number (ℝ)

Skewed Zeros

Distinct	48336
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.283892

Minimum	-4712.1
Maximum	74928.61
Zeros	192212
Zeros (%)	2.6%
Negative	12603
Negative (%)	0.2%
Memory size	111.8 MiB

Quantile statistics

Minimum	-4712.1
5-th percentile	2.89
Q1	10.32
median	22.01
Q3	44.7
95-th percentile	108.56
Maximum	74928.61
Range	79640.71
Interquartile range (IQR)	34.38

Descriptive statistics

Standard deviation	82.053691
Coefficient of variation (CV)	2.2614357
Kurtosis	107562.13
Mean	36.283892
Median Absolute Deviation (MAD)	14.46
Skewness	169.5704
Sum	2.6586685 × 10⁸
Variance	6732.8082
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	192212	2.6%
15.5	28759	0.4%
7	26524	0.4%
11.3	26045	0.4%
6	24440	0.3%
8	23779	0.3%
18.9	22187	0.3%
12	19656	0.3%
4	19559	0.3%
6.75	19254	0.3%
Other values (48326)	6924992	94.5%

Value	Count	Frequency (%)
-4712.1	1	< 0.1%
-3323.28	1	< 0.1%
-2625	1	< 0.1%
-2433.2	1	< 0.1%
-1200	1	< 0.1%
-1000	1	< 0.1%
-773.39	1	< 0.1%
-696.03	1	< 0.1%
-651.41	1	< 0.1%
-638.2	1	< 0.1%

Value	Count	Frequency (%)
74928.61	1	< 0.1%
33928.25	1	< 0.1%
25131.48	1	< 0.1%
23132.39	1	< 0.1%
22088.31	1	< 0.1%
21000	1	< 0.1%
20551.26	1	< 0.1%
19866	1	< 0.1%
19021.08	1	< 0.1%
16589.81	1	< 0.1%

venue_xref_id
Text

Distinct	465
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	559.9 MiB

Length

Max length	64
Median length	64
Mean length	64
Min length	64

Characters and Unicode

Total characters	468954048
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288
2nd row	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288
3rd row	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288
4th row	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288
5th row	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288

Value	Count	Frequency (%)
5e8a21ead84851c212c2cae58849de4d37bc0babfcab05ceff51350412eb3e94	85962	1.2%
6c4ddbba39d1529689be33c4769223b1194ba2dcb9e20f266d18face3279d00a	79705	1.1%
1fba23fbdd499646399a75417304d971f5fdea72bce5ba4b0d9e6086ac093892	74945	1.0%
68e559beb80a2ae3cbdbf07043ebf35fbbccd85494216a2f32b31da76ece5ac0	73329	1.0%
5dc459c71f4739c3dbd5872b4d442295864cf5715f704b19e02e1a581453561a	72665	1.0%
92128c7fc22f3f685e9914450a0bd855e258aafff9351663260b080a4a7c5188	68486	0.9%
6afc5202235f3b742e6482c94536ab8462f6022054eccb0c6d5630c211c0a7fe	66103	0.9%
5ece4507d7aec26fdcca66082fcc77457f79cea602c1a82122c7ea496d37c493	65298	0.9%
3c5a0e6460177d012e070306ba429335066823de1e25aa1ffbd3df7966cacd81	64713	0.9%
7cd024c525a7952ce599081035cf063cb3b0c52626072b2014a79055ef37d670	63627	0.9%
Other values (455)	6612574	90.2%

Most occurring characters

Value	Count	Frequency (%)
2	32191833	6.9%
e	31070515	6.6%
c	30968596	6.6%
0	29920795	6.4%
f	29749227	6.3%
b	29595969	6.3%
a	29270116	6.2%
3	29241722	6.2%
6	29107403	6.2%
d	28884875	6.2%
Other values (6)	168952997	36.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	468954048	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	32191833	6.9%
e	31070515	6.6%
c	30968596	6.6%
0	29920795	6.4%
f	29749227	6.3%
b	29595969	6.3%
a	29270116	6.2%
3	29241722	6.2%
6	29107403	6.2%
d	28884875	6.2%
Other values (6)	168952997	36.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	468954048	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	32191833	6.9%
e	31070515	6.6%
c	30968596	6.6%
0	29920795	6.4%
f	29749227	6.3%
b	29595969	6.3%
a	29270116	6.2%
3	29241722	6.2%
6	29107403	6.2%
d	28884875	6.2%
Other values (6)	168952997	36.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	468954048	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	32191833	6.9%
e	31070515	6.6%
c	30968596	6.6%
0	29920795	6.4%
f	29749227	6.3%
b	29595969	6.3%
a	29270116	6.2%
3	29241722	6.2%
6	29107403	6.2%
d	28884875	6.2%
Other values (6)	168952997	36.0%

waiter_uuid
Text

Distinct	7478
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	441.2 MiB

Length

Max length	49
Median length	49
Mean length	47.017436
Min length	20

Characters and Unicode

Total characters	344515887
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	255 ?
Unique (%)	< 0.1%

Sample

1st row	200421150750~37D0C51E-EC4F-4EA1-B549-D223DA183ABD
2nd row	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA
3rd row	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA
4th row	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA
5th row	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA

Value	Count	Frequency (%)
190405092446~8646fe39-600c-4318-bea7-0a31d4082914	384686	5.2%
200122200826~9afddbd1-59a4-4016-ad66-830100e21632	43219	0.6%
220808130537~4ff8785d-4a7b-49ff-a7fe-b8551b6591d0	38719	0.5%
150101000000~99c97c5b-82ae-48b5-a578-cc528ee0c57c	37387	0.5%
cc66dfde-4181-46f5-a04d-d14424650700	37364	0.5%
201209123916~356b9122-4031-4a51-886f-8dcea9d8afc5	36166	0.5%
220528101742~8c27e6e6-4320-45ad-aea9-fdb28a8364cd	31502	0.4%
160111173131~2be06004-30a3-4159-8213-0d8ece0549c4	27662	0.4%
191105151117~57504afc-9510-479d-bb67-82e999f616c2	26426	0.4%
230725153957~09eb7f75-4154-4ec6-83d7-c24ea0ca08ab	24989	0.3%
Other values (7468)	6639287	90.6%

Most occurring characters

Value	Count	Frequency (%)
4	29416383	8.5%
-	29309596	8.5%
0	28913626	8.4%
1	28490199	8.3%
2	27342752	7.9%
3	19948474	5.8%
9	19157625	5.6%
5	18667807	5.4%
8	18658318	5.4%
6	17348296	5.0%
Other values (23)	107262811	31.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	344515887	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	29416383	8.5%
-	29309596	8.5%
0	28913626	8.4%
1	28490199	8.3%
2	27342752	7.9%
3	19948474	5.8%
9	19157625	5.6%
5	18667807	5.4%
8	18658318	5.4%
6	17348296	5.0%
Other values (23)	107262811	31.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	344515887	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	29416383	8.5%
-	29309596	8.5%
0	28913626	8.4%
1	28490199	8.3%
2	27342752	7.9%
3	19948474	5.8%
9	19157625	5.6%
5	18667807	5.4%
8	18658318	5.4%
6	17348296	5.0%
Other values (23)	107262811	31.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	344515887	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	29416383	8.5%
-	29309596	8.5%
0	28913626	8.4%
1	28490199	8.3%
2	27342752	7.9%
3	19948474	5.8%
9	19157625	5.6%
5	18667807	5.4%
8	18658318	5.4%
6	17348296	5.0%
Other values (23)	107262811	31.1%

concept
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.8 MiB

FAMILY_DINING	2531818
CAFE	1445320
BAR	1248070
FAST_CASUAL	933396
BAKERY	305322
Other values (9)	863481

Length

Max length	21
Median length	13
Mean length	8.5454175
Min length	3

Characters and Unicode

Total characters	62615752
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BAR
2nd row	BAR
3rd row	BAR
4th row	BAR
5th row	BAR

Common Values

Value	Count	Frequency (%)
FAMILY_DINING	2531818	34.6%
CAFE	1445320	19.7%
BAR	1248070	17.0%
FAST_CASUAL	933396	12.7%
BAKERY	305322	4.2%
BREWERY	280258	3.8%
FINE_DINING	247651	3.4%
FAST_FOOD	191842	2.6%
HOTEL	52400	0.7%
ENTERTAINMENT_COMPLEX	51919	0.7%
Other values (4)	39411	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
family_dining	2531818	34.6%
cafe	1445320	19.7%
bar	1248070	17.0%
fast_casual	933396	12.7%
bakery	305322	4.2%
brewery	280258	3.8%
fine_dining	247651	3.4%
fast_food	191842	2.6%
hotel	52400	0.7%
entertainment_complex	51919	0.7%
Other values (4)	39411	0.5%

Most occurring characters

Value	Count	Frequency (%)
A	8574479	13.7%
I	8390326	13.4%
N	5962346	9.5%
F	5600247	8.9%
_	3976343	6.4%
L	3569547	5.7%
Y	3117398	5.0%
D	2990301	4.8%
E	2838579	4.5%
G	2779469	4.4%
Other values (13)	14816717	23.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	62615752	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	8574479	13.7%
I	8390326	13.4%
N	5962346	9.5%
F	5600247	8.9%
_	3976343	6.4%
L	3569547	5.7%
Y	3117398	5.0%
D	2990301	4.8%
E	2838579	4.5%
G	2779469	4.4%
Other values (13)	14816717	23.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	62615752	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	8574479	13.7%
I	8390326	13.4%
N	5962346	9.5%
F	5600247	8.9%
_	3976343	6.4%
L	3569547	5.7%
Y	3117398	5.0%
D	2990301	4.8%
E	2838579	4.5%
G	2779469	4.4%
Other values (13)	14816717	23.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	62615752	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	8574479	13.7%
I	8390326	13.4%
N	5962346	9.5%
F	5600247	8.9%
_	3976343	6.4%
L	3569547	5.7%
Y	3117398	5.0%
D	2990301	4.8%
E	2838579	4.5%
G	2779469	4.4%
Other values (13)	14816717	23.7%

city
Text

Distinct	295
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	170.0 MiB

Length

Max length	25
Median length	20
Mean length	8.2089334
Min length	3

Characters and Unicode

Total characters	60150196
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Grand Forks
2nd row	Grand Forks
3rd row	Grand Forks
4th row	Grand Forks
5th row	Grand Forks

Value	Count	Frequency (%)
toronto	1001138	12.0%
vancouver	602167	7.2%
ottawa	283547	3.4%
calgary	256330	3.1%
houston	189250	2.3%
edmonton	154532	1.8%
banff	137289	1.6%
mississauga	129973	1.6%
york	125956	1.5%
denver	121743	1.5%
Other values (316)	5372203	64.2%

Most occurring characters

Value	Count	Frequency (%)
o	7565385	12.6%
a	5260106	8.7%
n	5003485	8.3%
r	4574222	7.6%
t	4010475	6.7%
e	3960850	6.6%
i	2872052	4.8%
l	2247121	3.7%
s	2115147	3.5%
u	1711412	2.8%
Other values (44)	20829941	34.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	60150196	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	7565385	12.6%
a	5260106	8.7%
n	5003485	8.3%
r	4574222	7.6%
t	4010475	6.7%
e	3960850	6.6%
i	2872052	4.8%
l	2247121	3.7%
s	2115147	3.5%
u	1711412	2.8%
Other values (44)	20829941	34.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	60150196	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	7565385	12.6%
a	5260106	8.7%
n	5003485	8.3%
r	4574222	7.6%
t	4010475	6.7%
e	3960850	6.6%
i	2872052	4.8%
l	2247121	3.7%
s	2115147	3.5%
u	1711412	2.8%
Other values (44)	20829941	34.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	60150196	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	7565385	12.6%
a	5260106	8.7%
n	5003485	8.3%
r	4574222	7.6%
t	4010475	6.7%
e	3960850	6.6%
i	2872052	4.8%
l	2247121	3.7%
s	2115147	3.5%
u	1711412	2.8%
Other values (44)	20829941	34.6%

country
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.8 MiB

CA	4589801
US	2737606

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	14654814
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	US
2nd row	US
3rd row	US
4th row	US
5th row	US

Common Values

Value	Count	Frequency (%)
CA	4589801	62.6%
US	2737606	37.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ca	4589801	62.6%
us	2737606	37.4%

Most occurring characters

Value	Count	Frequency (%)
C	4589801	31.3%
A	4589801	31.3%
U	2737606	18.7%
S	2737606	18.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	14654814	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	4589801	31.3%
A	4589801	31.3%
U	2737606	18.7%
S	2737606	18.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	14654814	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	4589801	31.3%
A	4589801	31.3%
U	2737606	18.7%
S	2737606	18.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	14654814	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	4589801	31.3%
A	4589801	31.3%
U	2737606	18.7%
S	2737606	18.7%

start_of_day_offset
Categorical

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	111.8 MiB

00:00:00	4249611
05:00:00	692339
04:00:00	615708
06:00:00	453733
07:00:00	331455
Other values (13)	984561

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	58619256
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	03:00:00
2nd row	03:00:00
3rd row	03:00:00
4th row	03:00:00
5th row	03:00:00

Common Values

Value	Count	Frequency (%)
00:00:00	4249611	58.0%
05:00:00	692339	9.4%
04:00:00	615708	8.4%
06:00:00	453733	6.2%
07:00:00	331455	4.5%
08:00:00	198770	2.7%
03:00:00	187945	2.6%
09:00:00	144448	2.0%
02:00:00	116913	1.6%
10:00:00	112852	1.5%
Other values (8)	223633	3.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	4249611	58.0%
05:00:00	692339	9.4%
04:00:00	615708	8.4%
06:00:00	453733	6.2%
07:00:00	331455	4.5%
08:00:00	198770	2.7%
03:00:00	187945	2.6%
09:00:00	144448	2.0%
02:00:00	116913	1.6%
10:00:00	112852	1.5%
Other values (8)	223633	3.1%

Most occurring characters

Value	Count	Frequency (%)
0	40737456	69.5%
:	14654814	25.0%
5	711378	1.2%
4	622421	1.1%
6	460300	0.8%
1	369787	0.6%
7	351719	0.6%
3	200880	0.3%
8	198770	0.3%
2	167283	0.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	58619256	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	40737456	69.5%
:	14654814	25.0%
5	711378	1.2%
4	622421	1.1%
6	460300	0.8%
1	369787	0.6%
7	351719	0.6%
3	200880	0.3%
8	198770	0.3%
2	167283	0.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	58619256	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	40737456	69.5%
:	14654814	25.0%
5	711378	1.2%
4	622421	1.1%
6	460300	0.8%
1	369787	0.6%
7	351719	0.6%
3	200880	0.3%
8	198770	0.3%
2	167283	0.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	58619256	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	40737456	69.5%
:	14654814	25.0%
5	711378	1.2%
4	622421	1.1%
6	460300	0.8%
1	369787	0.6%
7	351719	0.6%
3	200880	0.3%
8	198770	0.3%
2	167283	0.3%

Interactions

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	bill_paid_at_local	bill_total_billed	bill_total_discount_item_level	bill_total_net	bill_total_tax	bill_uuid	business_date	order_duration_seconds	order_seated_at_local	order_closed_at_local	order_take_out_type_label	order_uuid	payment_amount	payment_count	payment_total_tip	sales_revenue_with_tax	venue_xref_id	waiter_uuid	concept	city	country	start_of_day_offset
7943	2024-07-02 20:00:53	102.53	0.0	95.0	7.53	240702200053~8792ADCC-545E-4AF3-9836-9C428ED8285C	2024-07-02	5071	2024-07-02 18:36:22	2024-07-02 20:00:53	dinein	240702183622~4B0A3D27-501D-4C94-BEBC-7B7F3C91A0F4	124.53	1	22.00	102.53	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	200421150750~37D0C51E-EC4F-4EA1-B549-D223DA183ABD	BAR	Grand Forks	US	03:00:00
7944	2024-07-03 21:43:39	5.38	5.0	5.0	0.38	240703214339~B06B2A2F-B1A0-44C0-920A-242F41B58BD2	2024-07-03	6968	2024-07-03 19:47:31	2024-07-03 21:43:39	dinein	240703194731~40651D6D-4A16-4889-8C12-0F9A00D8BCF7	5.38	1	0.00	5.38	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA	BAR	Grand Forks	US	03:00:00
7945	2024-07-03 18:23:56	141.90	0.0	132.0	9.90	240703182356~D082FE98-841C-4EAB-B15E-BEA41FA1CDF0	2024-07-03	2011	2024-07-03 17:50:25	2024-07-03 18:23:56	dinein	240703175025~0AEB61B0-220A-45A3-807E-78A1F432BB4C	171.90	1	30.00	141.90	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA	BAR	Grand Forks	US	03:00:00
7946	2024-07-03 19:33:21	63.77	0.0	59.0	4.77	240703193321~273CBB07-FAB0-49B7-A445-8474F9A4570F	2024-07-03	5480	2024-07-03 18:02:01	2024-07-03 19:33:21	dinein	240703180201~4B276496-BE92-4DE6-BD75-565929827014	73.77	1	10.00	63.77	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA	BAR	Grand Forks	US	03:00:00
7947	2024-07-05 21:01:14	210.65	0.0	195.0	15.65	240705210114~D423B906-1AEE-4DB8-84BA-234267A14E05	2024-07-05	4773	2024-07-05 19:41:41	2024-07-05 21:01:14	dinein	240705194141~F90FEB4F-D238-449E-B476-D16966DF4EEC	252.65	1	42.00	210.65	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA	BAR	Grand Forks	US	03:00:00
7948	2024-07-05 21:09:26	50.93	0.0	47.0	3.93	240705210926~CA81A307-A782-42D4-B81D-250556CBE839	2024-07-05	4820	2024-07-05 19:49:06	2024-07-05 21:09:26	dinein	240705194906~A090563D-5272-4F52-AD09-9316178D53F5	60.93	1	10.00	50.93	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA	BAR	Grand Forks	US	03:00:00
7949	2024-07-05 20:21:48	157.94	0.0	146.0	11.94	240705202148~A47EEC00-A5AF-45BA-A892-171E7CDEFE7C	2024-07-05	5555	2024-07-05 18:49:13	2024-07-05 20:21:48	dinein	240705184913~CEE4782F-A70E-4F8F-8912-BCFC97B5AD35	187.94	1	30.00	157.94	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA	BAR	Grand Forks	US	03:00:00
7950	2024-07-05 18:23:18	151.58	0.0	141.0	10.58	240705182318~913C3F9F-E867-4E36-A3B1-E1E68FCBAD16	2024-07-05	4263	2024-07-05 17:12:15	2024-07-05 18:23:18	dinein	240705171215~0EE5ACBB-3F73-4E16-A806-FF4084E46F5F	181.58	1	30.00	151.58	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA	BAR	Grand Forks	US	03:00:00
7951	2024-07-06 17:46:32	79.55	0.0	74.0	5.55	240706174632~1996E368-132E-43A2-9821-34BF48033CE1	2024-07-06	1904	2024-07-06 17:14:48	2024-07-06 17:46:32	dinein	240706171448~3E583E38-3B31-45E7-A0BE-57C18EA214A7	79.55	1	0.00	79.55	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	220104154507~89085BB4-771B-40A1-9D20-B9745CC1DAFA	BAR	Grand Forks	US	03:00:00
7952	2024-07-06 18:17:22	56.64	0.0	52.5	4.14	240706181722~A4851319-949C-4FF1-964D-C860684075B9	2024-07-06	2077	2024-07-06 17:42:45	2024-07-06 18:17:22	dinein	240706174245~80595C36-1C6B-4842-88D1-B5BD7E063DE8	68.00	1	11.36	56.64	885332b7f22a142e21b7459473003fddc17bfca5753ceb2f0f0d63cdf9de4288	230816152907~E53E7ACE-FD5E-4E0B-B059-25E513F576B2	BAR	Grand Forks	US	03:00:00

	bill_paid_at_local	bill_total_billed	bill_total_discount_item_level	bill_total_net	bill_uuid	business_date	order_duration_seconds	order_seated_at_local	order_closed_at_local	order_take_out_type_label	order_uuid	payment_amount	payment_count	sales_revenue_with_tax	venue_xref_id	waiter_uuid	concept	city	country	start_of_day_offset
167154	2024-12-27 17:40:58	24.98	0.00	24.98	241227174057~0A0B75D8-71B8-4625-80D8-91924BA9E18E	2024-12-27	507	2024-12-27 17:32:31	2024-12-27 17:40:58	takeout	241227173231~6B94AD74-4C11-4977-8A1D-2CD15C39AB36	24.98	1	24.98	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	221116163611~F844A24E-44E8-40F2-B6D0-073FF805DBF7	FAMILY_DINING	Edmonton	CA	00:00:00
167155	2024-12-27 17:54:19	78.43	0.00	78.43	241227175419~FDCA9A8B-8515-47A8-B438-E95FE1B7177B	2024-12-27	3853	2024-12-27 16:50:06	2024-12-27 17:54:19	dinein	241227165006~8559E840-33DD-47EA-844E-211E68ED17A3	78.43	1	78.43	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230202164435~D6FB6D1F-F2E2-4DB2-8278-59AAFF09A7F4	FAMILY_DINING	Edmonton	CA	00:00:00
167156	2024-12-27 21:32:43	108.90	0.00	108.90	241227213243~3465F212-5737-4B4A-9FE4-B528E630C08D	2024-12-27	3859	2024-12-27 20:28:24	2024-12-27 21:32:43	dinein	241227202824~BB60AF10-4446-4659-9F0C-B7E3942B62EA	108.90	1	108.90	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230202164435~D6FB6D1F-F2E2-4DB2-8278-59AAFF09A7F4	FAMILY_DINING	Edmonton	CA	00:00:00
167157	2024-12-28 19:58:00	75.42	0.00	75.42	241228195800~416C102D-5E2B-47B7-9EA3-4D4D56367D96	2024-12-28	3087	2024-12-28 19:06:33	2024-12-28 19:58:00	dinein	241228190633~A3D5144B-B4E1-4855-8718-B7995717B526	75.42	1	75.42	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6	FAMILY_DINING	Edmonton	CA	00:00:00
167158	2024-12-28 20:38:29	99.92	0.00	99.92	241228203829~D10C3768-50E1-4E52-8F0A-F5CBA575A514	2024-12-28	7419	2024-12-28 18:34:50	2024-12-28 20:38:29	dinein	241228183450~DAE45042-47AA-4DF0-A580-4EB72ACB8763	99.92	1	99.92	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6	FAMILY_DINING	Edmonton	CA	00:00:00
167159	2024-12-29 20:32:54	82.42	0.00	82.42	241229203254~464AA06D-F986-4C51-8A53-A7B8362072D6	2024-12-29	4382	2024-12-29 19:19:52	2024-12-29 20:32:54	dinein	241229191952~96F91DE2-5ECC-4AC9-9228-B0741F3494B1	82.42	1	82.42	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	220831171122~1455DBA8-211C-4281-BF27-8698365CA3EB	FAMILY_DINING	Edmonton	CA	00:00:00
167160	2024-12-30 20:36:19	87.92	0.00	87.92	241230203619~37348A86-98D1-4113-8EDD-06A3CF61A85B	2024-12-30	5244	2024-12-30 19:08:55	2024-12-30 20:36:19	dinein	241230190855~BB4604F2-B7BA-487A-99AF-7AEB77CA3EEC	87.92	1	87.92	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6	FAMILY_DINING	Edmonton	CA	00:00:00
167161	2024-12-31 14:24:23	51.96	0.00	51.96	241231142423~9D2E9295-9E59-4E76-8242-D230C9FD2494	2024-12-31	963	2024-12-31 14:08:20	2024-12-31 14:24:23	takeout	241231140820~4D531668-3D68-4789-A1DB-BE324D4583D5	51.96	1	51.96	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	161216233231~64B016BA-D9BA-49C7-8726-4BCB6516A11D	FAMILY_DINING	Edmonton	CA	00:00:00
167162	2024-12-31 17:00:34	49.35	11.59	49.35	241231170034~A9B4401D-26DC-4FC5-A4F9-0261D950DB3B	2024-12-31	59	2024-12-31 16:59:35	2024-12-31 17:00:34	takeout	241231165935~27989697-086C-4F7C-8AB2-8C0A8B2CF3A7	49.35	1	49.35	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6	FAMILY_DINING	Edmonton	CA	00:00:00
167163	2024-12-31 18:55:07	88.42	0.00	88.42	241231185507~62C6632E-2957-4F0D-8AFF-CF89CA378FB4	2024-12-31	6556	2024-12-31 17:05:51	2024-12-31 18:55:07	dinein	241231170551~4DEE5611-B193-40FB-858B-0650CE2F7259	88.42	1	88.42	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6	FAMILY_DINING	Edmonton	CA	00:00:00

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)